package come.pbms.nursing.mapper;

import com.github.pagehelper.Page;
import come.pbms.nursing.domain.NursingServe;
import org.apache.ibatis.annotations.*;

@Mapper
public interface NursingMapper {

    Page<NursingServe> page(@Param("status") Integer status, @Param("serviceName") String serviceName);

    @Insert("insert into  value_added_service (service_name,price,description,status) values (#{serviceName},#{price},#{description},#{status});")
    boolean insertNursingServe(NursingServe nursingServe);

    @Select("select service_id,service_name,price,description,status from value_added_service service where service_id=#{serviceId}")
    NursingServe getById(Integer serviceId);

    boolean update(NursingServe nursingServe);

    @Delete("delete from value_added_service where service_id=#{serviceId}")
    int deleteById(Integer serviceId);
}
